﻿CREATE TABLE [dbo].[YarnType_Tbl] (
    [YarnTypeID]        INT           IDENTITY (1, 1) NOT NULL,
    [YarnType]          NVARCHAR (50) NULL,
    [Denier]            INT           NULL,
    [Unit]              NVARCHAR (50) NULL,
    [ModTensilegperDen] FLOAT         NULL,
    [Strengthgperd]     FLOAT         NULL,
    [CostFactor]        FLOAT         NULL,
    [Stocked]           BIT           NULL,
    [AccountancyItemID] NVARCHAR (50) NULL
);

